Deltek Acumen 8.5 Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information: Searching Online Help

IF

The IF function returns one value if the specified condition is TRUE and returns another value if the specified condition is FALSE.

IF(logical_test, value_if_true, [value_if_false])

  • Logical_test (Required) is any value or expression that can be evaluated to TRUE or FALSE.
  • Value_if_true (Required) is the value to be returned if the "logical_test" argument evaluates to TRUE.
  • Value_if_false (Optional) is the value to be returned if the "logical_test" argument evaluates to FALSE. If omitted then zero is returned.

Example: IF(TaskStatus="Inprogress",1,0) returns 1 if the activity status is equal to InProgress otherwise 0 is returned.

You can write IF statements in shorthand within Acumen Fuse. If the IF function name and Value_if_true and Value_if_false parameters are omitted, the Acumen Fuse engine will assume that the function is an IF statement returning either a 1 or a 0.

Example: IF(TaskStatus="Inprogress",1,0) can be written in shorthand as (TaskStatus="Inprogress").